import pandas as pd

# 读取Excel文件
file_path = 'D:\箱号.xlsx'
df = pd.read_excel(file_path)

# 假设Excel文件中有两列：旧盒号 和 新盒号
for index, row in df.iterrows():
    old_box = row['旧盒号']
    new_box = row['新盒号']
    sql = f"UPDATE fa_pack SET big_box = '{new_box}' WHERE big_box = '{old_box}';"
    print(sql)